﻿CREATE TABLE [dbo].[COHOI] (
    [IdDoiTuong]    UNIQUEIDENTIFIER NOT NULL,
    [MaHieu]        NCHAR (100)      NOT NULL,
    [TenCoHoi]      NCHAR (100)      NOT NULL,
    [MaToChuc]      NCHAR (100)      NOT NULL,
    [MaChienDich]   NCHAR (100)      NULL,
    [Loai]          NCHAR (100)      NOT NULL,
    [NguonGoc]      NCHAR (100)      NULL,
    [SoTien]        FLOAT            NULL,
    [GiaiDoan]      NCHAR (100)      NOT NULL,
    [BuocTiepTheo]  NCHAR (100)      NULL,
    [LyDoThangThua] NCHAR (100)      NULL,
    [NgayKyVong]    DATETIME         NOT NULL,
    [DienGiai]      NVARCHAR (MAX)   NULL,
    [NgayKetThuc]   DATETIME         NULL
);

